| Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
| CustomerGroupID (FK)(PK) | A unique identification number assigned to a customer group | ID_GP_ID | Identity | integer | CustomerGroup(PA_GP_CT) |
| CustomerID (FK)(PK) | A unique system assigned identifier for a person or organization that purchases a product or service from the retailer. | ID_CT | Identity | integer | KeyCustomer(PA_KY_CT) |
| IdentityVerifyRequiredFlag | A flag to denote whether the CUSTOMER's identity has been verified as belonging to the CUSTOMER AFFILIATION scheme. | FL_IDN_CTAF_VR_RQ | Flag | integer | |
| EffectiveDate | Date this CustomerAffiliation is active | DC_EF | EffectiveDate | date | |
| ExpirationDate | Date this CustomerAffiliation is inactive | DC_EP | ExpirationDate | date | |
| StatusCode | Current status of this CustomerAffiliation. Values: I = Inactive A = Active | CD_STS | Code2Status | char(2) | |